UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HEVO9UuMIdzAJPTk0V0cj+NKFN2Qjyw22hKzngT098s='
WHERE
key_id = '9c88b3672517bef3cb3e4037b60120d13c7526f972ffa6a745418a4a03f53586'
AND (
token = 'HEVO9UuMIdzAJPTk0V0cj+NKFN2Qjyw22hKzngT098s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)