UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nvFl8FZp7zEQnGb+J10QW5xOMq5keyh06OLVwDw8nfw='
WHERE
key_id = '1de638e563e84164c4b1d8db677d4115ec4d39fb36c16e592ca8c3165faa6c9c'
AND (
token = 'nvFl8FZp7zEQnGb+J10QW5xOMq5keyh06OLVwDw8nfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)