UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yncVPE7WA6pt+fTnvsUgKx7a17y7KNVIn6yIX6zhRhU='
WHERE
key_id = '1e132a2c407e28a24b764c00e4170f795873d60ce4c177ea7433cac7b29d52ad'
AND (
token = 'yncVPE7WA6pt+fTnvsUgKx7a17y7KNVIn6yIX6zhRhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)