UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/BolhvWmzF+vgZ/8aAXO9aCmqOll4T1bjVs2hee+w/E='
WHERE
key_id = 'bf852e2f7bf2362eeaa6295d0685cbaf7812c568e1afc16dd43ea884b5300ca8'
AND (
token = '/BolhvWmzF+vgZ/8aAXO9aCmqOll4T1bjVs2hee+w/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)