UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LpZHAlBFhS5jxFjFlYbLiHat7V09AS7doB4l/rXF0iI='
WHERE
key_id = 'f4b58b0272f63b76ac785a2d4721c0285d1a1add34be856ccf9b3ea987e6a875'
AND (
token = 'LpZHAlBFhS5jxFjFlYbLiHat7V09AS7doB4l/rXF0iI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)