UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o/H5F23ytfJ6JWtue7wANcTESjgp5p8iSo2o008b4uM='
WHERE
key_id = 'b542f65ea8a5c4d64c00170605d3b3842edb3553eb8fb5ab56f22357a889201b'
AND (
token = 'o/H5F23ytfJ6JWtue7wANcTESjgp5p8iSo2o008b4uM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)