UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NNkwbSj+V4YNgBqmVnK2Kl1YTsD8gcBop03z1putJvc='
WHERE
key_id = 'c4c9a6925f22a055d216cc639b35ee3f5d2a022efb7cc43e7e49076face0aecd'
AND (
token = 'NNkwbSj+V4YNgBqmVnK2Kl1YTsD8gcBop03z1putJvc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)