UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CUDj1OsB5iQWtjL4BPqCrUsoZ+PVhT9oTV1Om6Pr+us='
WHERE
key_id = 'e188bea43fdf5c6b6d7a84b6a8325ffa12c83ddd41b89b011858a4a808682392'
AND (
token = 'CUDj1OsB5iQWtjL4BPqCrUsoZ+PVhT9oTV1Om6Pr+us='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)