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