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