UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DmvIq707aCTjTMWK1PVURCijAXz2rCaNRGbzLXdZJ60='
WHERE
key_id = '864c284db077e73b0794af180533bb37a47dcb82c026c1882c18c7de6080940e'
AND (
token = 'DmvIq707aCTjTMWK1PVURCijAXz2rCaNRGbzLXdZJ60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)