UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JfIMcdvvG5MIUjaW4ODpsc7fQvklxudPt2GWdCycirk='
WHERE
key_id = '963d64a7739d0513b27b30623219d1698d8ccc1e4518bda1ec381023de382d9d'
AND (
token = 'JfIMcdvvG5MIUjaW4ODpsc7fQvklxudPt2GWdCycirk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)