UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0nukWJ4fnvpYieAmXrCucQWr7TPzwpQ1b8lrg01j7e8='
WHERE
key_id = 'd4141f928f72cae0c46f959c0964949513d6b252cb7eb6d7e69c4300f4ee72cd'
AND (
token = '0nukWJ4fnvpYieAmXrCucQWr7TPzwpQ1b8lrg01j7e8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)