UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UcaA8zFsf7ub6dDAw0LD+C2xzGPDqqgeh0j8vYtvOmA='
WHERE
key_id = '1a89e9acb14dd21b777edc401101ae0657b0b6144387e14d0061b4f188b0dea2'
AND (
token = 'UcaA8zFsf7ub6dDAw0LD+C2xzGPDqqgeh0j8vYtvOmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)