UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4zeA3+By5tT2YmAx54/elhXLtoFTK92m2FsAiCKlpdo='
WHERE
key_id = 'e220264470cde13e44953211152c9389fb859d3b55fcd9b8abf2336bc241b11a'
AND (
token = '4zeA3+By5tT2YmAx54/elhXLtoFTK92m2FsAiCKlpdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)