UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4XPl3A29LS31vTB5sh6bTzDEuwz2Rw6yDt7Q6vHM15M='
WHERE
key_id = 'bd30cd97d797aa47f049d6711f0f3b95c87039aeec3322a79a8352c56011854f'
AND (
token = '4XPl3A29LS31vTB5sh6bTzDEuwz2Rw6yDt7Q6vHM15M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)