UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z1fHL2hPmPdCIdwnErxkDLCx1V6xUzsEFyMmWVB9C/I='
WHERE
key_id = '6ed8e8a53ad8e77699a6daade6bf5dd81c8cbafc390e180360fd5831cd127ab7'
AND (
token = 'Z1fHL2hPmPdCIdwnErxkDLCx1V6xUzsEFyMmWVB9C/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)