UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XHHPG41yylHgyD3XR2N53wBUjiZzSbLhN3s0V54F/8A='
WHERE
key_id = '3a19d29a54cc0086a8b578363f1b93bf1226f31c94c771f098151623d74dfa1c'
AND (
token = 'XHHPG41yylHgyD3XR2N53wBUjiZzSbLhN3s0V54F/8A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)