UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CaOOEnuSGx9kN9HbV6B4NrsBc9TCfecTBHFzEsFV5Yk='
WHERE
key_id = 'd1f1f803402c3a100cbcde712fd06581871463e9b8be326e26cdb66cb8a260a5'
AND (
token = 'CaOOEnuSGx9kN9HbV6B4NrsBc9TCfecTBHFzEsFV5Yk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)