UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fFPRaYXpYGon3J/bPQgtzYfd0JrIsIFz46e6h504uFw='
WHERE
key_id = '2f829f0156a37a86942bf65dbf769c25b41135e1d046e4d6f77db99965b0c30c'
AND (
token = 'fFPRaYXpYGon3J/bPQgtzYfd0JrIsIFz46e6h504uFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)