UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i7YAcyMJnhJGxFyg/bHjzSbNOky51iAmDWnPIO4jPO4='
WHERE
key_id = '4aa53b75327f340eb93d521e96f38b2ab962a9a4b0eaf1a14dfd342fe8735ce5'
AND (
token = 'i7YAcyMJnhJGxFyg/bHjzSbNOky51iAmDWnPIO4jPO4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)