UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fQAgmNsj78LBC6B2r4EmOWFcDqBhnLurEK6F+B/Q/PM='
WHERE
key_id = 'df816a216c985123635b491f0918098c7d8355b48d85eda6e73f806fa01daab5'
AND (
token = 'fQAgmNsj78LBC6B2r4EmOWFcDqBhnLurEK6F+B/Q/PM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)