UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yc2UtO1kppJ09VX8hGw7lI78rt6ozIA2K5kr9iqJ48k='
WHERE
key_id = '78ab0ba9a0f5433a909c1ca273a86e85b182dc0795de4d8c0ea101a38ce3b7c7'
AND (
token = 'yc2UtO1kppJ09VX8hGw7lI78rt6ozIA2K5kr9iqJ48k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)