UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WRkdt1MzYMjOqudjI5RQdfcYVJxrsQTuNfS48WUKTm0='
WHERE
key_id = 'e0a40c7539c5bea4c323a32437076a6b13f86495117c024afe082dd397f8e344'
AND (
token = 'WRkdt1MzYMjOqudjI5RQdfcYVJxrsQTuNfS48WUKTm0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)