UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dTKAcIf8iR+2U6eHjE+GHCS6O2xat/DuriBut+OX+Uo='
WHERE
key_id = 'f863f104e3249aa97a1769f675dd48467f1860677b1eae2b2bc3fe3f6fc9087d'
AND (
token = 'dTKAcIf8iR+2U6eHjE+GHCS6O2xat/DuriBut+OX+Uo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)