UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'keNYO/GPePn+R7GR8E6edsHBYs8i+6Tm6vS8Pcb+4mE='
WHERE
key_id = '0d529a1436d5a81b7c85e298ef2441d31754c4bb0e65f75be5fc63b7dd9a9b3b'
AND (
token = 'keNYO/GPePn+R7GR8E6edsHBYs8i+6Tm6vS8Pcb+4mE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)