UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9cJ7hWcXWqQ3+QPCgxgqBkyWfx9gNaZagbr8RWxP0/4='
WHERE
key_id = '8b4b9525375059122a96255be77dae78979fed2356c108006a07606a769ae68d'
AND (
token = '9cJ7hWcXWqQ3+QPCgxgqBkyWfx9gNaZagbr8RWxP0/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)