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