UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X5kk07SwWY4yZuaXbe2hL9nMsau4RqcAntLoMIqJz2Y='
WHERE
key_id = '3cdd8659022d0fc356bb402fa46871f6c6290a1c20b9c4dfc4350c0889e792ca'
AND (
token = 'X5kk07SwWY4yZuaXbe2hL9nMsau4RqcAntLoMIqJz2Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)