UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ZmRwq8D8AFclzKYSz72TeY0Qcgos6p1bEhOIoCoxmc='
WHERE
key_id = 'a1dc4a8e3e418de84716b05c2c8363853d2224431f133bc8de2855ea4fe023a1'
AND (
token = '6ZmRwq8D8AFclzKYSz72TeY0Qcgos6p1bEhOIoCoxmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)