UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pEFhI8IW2CBdARZi3b2OV7r+y0f67b63R1Ey6m8tucA='
WHERE
key_id = '1d31e3f12965b24db91f205c79502d74f2b0a8369c2547071bebd5d2b0cda832'
AND (
token = 'pEFhI8IW2CBdARZi3b2OV7r+y0f67b63R1Ey6m8tucA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)