UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hSd4g1JvAGlekWb3XZLipiZHwW4olUosGL9BlVg6q9U='
WHERE
key_id = 'e89a31cf8a3a74b8b9b478e2b8fdf2f8b8e77d73788f2d8c96bcf832a31b0f73'
AND (
token = 'hSd4g1JvAGlekWb3XZLipiZHwW4olUosGL9BlVg6q9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)